package com.hualan.sfzy.mapper;


import com.hualan.sfzy.model.entity.PsychologyTest;
import com.hualan.sfzy.model.entity.PsychologyTestClassify;
import org.apache.ibatis.annotations.Mapper;
import org.apache.ibatis.annotations.Param;

import java.util.List;

/**
* @author Ahao
* @description 针对表【psychology_test】的数据库操作Mapper
* @createDate 2025-07-07 21:05:01
* @Entity com.hualan.domain.PsychologyTest
*/
@Mapper
public interface PsychologyTestMapper extends BaseMapper<PsychologyTest> {
    /*根据id查询单个(多表)*/
    PsychologyTest selectByIdDuo(Integer id);

    /*根据id修改*/
    int updateById(PsychologyTest record);

    /*多表查询*/
    List<PsychologyTest> selectDuo();

    /*查询所有分类*/
    List<PsychologyTest> selectAllClassify();

    /*根据title(模糊)，introduction(模糊)，classifyName多条件查询*/
    List<PsychologyTest> findByCondition(PsychologyTest entity);

    /*查询所有id 和对应的 title*/
    List<PsychologyTest> selectAllIdAndTitle();

    /*根据testClassifyId查询*/
    List<PsychologyTest> selectAllTitleAndOptions(@Param("testId") Integer testId);



}
